alter table jms_dim.dim_tms_mainline_vehicleloading set tblproperties ('external.table.purge'='true');
drop table if exists jms_dim.dim_tms_mainline_vehicleloading;
CREATE EXTERNAL TABLE `jms_dim.dim_tms_mainline_vehicleloading`(
  `id` bigint COMMENT 'id', 
  `distributecode` string COMMENT '转运中心编码', 
  `distributename` string COMMENT '转运中心', 
  `vehicletype` string COMMENT '车型', 
  `vehiclevolume` string COMMENT '核载体积m3', 
  `vehicleweight` string COMMENT '核载重量(单位：吨)', 
  `vehiclecount` string COMMENT '核载票数', 
  `operator` string COMMENT '操作人', 
  `operatortime` timestamp COMMENT '每票平均体积m3', 
  `averagevolume` string COMMENT '代理区编码', 
  `agentcode` string COMMENT '代理区编码', 
  `agentname` string COMMENT '代理区名称')
COMMENT '干线核载维护表'
STORED AS PARQUET
LOCATION '/dw/hive/jms_dim.db/external/dim_tms_mainline_vehicleloading'
tblproperties (
'discover.partitions' = 'false',
'parquet.column.index.access' = 'true'
);